Skip to main content Skip to complementary content
Close announcements banner

Interprocess communication via named pipes

Two types of named pipes are used for exchanging messages and data between Qlik Sense or QlikView and Connector:

  • Command pipe is a named pipe that is used for exchanging XML formatted messages,that is, Qlik Sense and QlikView requests, which describe commands to be performed by the Connector, and the Connector replies, which describe status of the executed commands. In certain cases, replies may include result data.
  • Data pipe is a named pipe that is used by the Connector to return QVX formatted data, for example, SQL statement result. For every QVX_EXECUTE command request a new data pipe is created.

Illustration of interprocess communication: QlikView and Qlik Sense pass info via the command pipe to the Qlik Custom Connector, which returns both info via the Command pipe and data via the Data pipe

Below are example scenarios on how Qlik Sense (and QlikView) and the Connector exchange messages to execute

Connect statement

  1. Qlik Sense or QlikView sends a connect request (QVX_CONNECT) through the command pipe and waits for the Connector reply.
  2. The Connector executes the connect command and sends the reply if the connection to the data source was successful or not (QVX_OK or QVX_CONNECT_ERROR).

Select statement

  1. Qlik Sense or QlikView sends an execute request (QVX_EXECUTE) and waits for the Connector reply. The request includes the SQL statement and the name of a data pipe, by which QVX formatted result should be returned.
  2. After executing SQL statement, the Connector sends the reply on the execute command execution status, e.g. QVX_OK or QVX_TABLE_NOT_FOUND.
  3. The Connector starts writing SQL statement result data to the data pipe.
  4. Qlik Sense and QlikView, after receiving QVX_OK reply to the execute request, start reading data from the data pipe.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com